Prerequisites

This topic list the prerequisites for using the SAP Sybase ASE source endpoint in a replication task.

General prerequisites

• Enable SAP Sybase ASE replication for tables using the sp_setreptable command or set privileges to enable it automatically.

• Turn off automatic truncation by running the following command:

  sp_dboption mydb, "trunc log on chkpt", false

  go

Prerequisites when using LogTransfer CDC

In order to use LogTransfer CDC in the Advanced tab, you must first disable RepAgent on the SAP Sybase ASE database.

Prerequisites when using RepAgent CDC

In order to use RepAgent CDC in the Advanced tab, make sure you have fulfilled the following prerequisites on the SAP Sybase ASE database.

Configure RepAgent

Configure RepAgent on Sybase ASE (using sp_config_rep_agent). For more information, see Enabling RepAgent at the Primary Database.  

Example syntax:

sp_config_rep_agent <dbname>, enable, "REPLICATE", "xxx", "password"

sp_config_rep_agent <dbname>, 'net password encryption', 'false'

Where <dbname> is the name of the Sybase ASE database.

Edit the sql.ini file

Edit the <Sybase_root>\ini\sql.ini (Windows) or <Sybase_root>\interfaces (Unix) file as follows:

[REPLICATE]

master=TCP,<replicate-hostname>,11765

query=TCP,<replicate-hostname>,11765

Where <replicate-hostname> name is the IP address or host name of the Qlik Replicate server machine and 11765 is the default listening port. You can specify a different port, but whatever port you specify needs to be specified in the endpoint settings as well.

Replicate on Windows

Install SAP Adaptive Server Enterprise ODBC Driver 16.0 or 16.1 (64-bit) on the Qlik Replicate computer.

Replicate on Linux

1. Stop the Replicate service and optionally confirm that it has stopped as described in Replicate server procedures.

2. Install SAP Adaptive Server Enterprise ODBC Driver 16.0 or 16.1 (64-bit) on the Qlik Replicate computer.
   Information noteThe Linux ODBC Driver 16.1 is only supported on RHEL 9 or later.

3. After the driver is installed, verify that the /etc/odbcinst.ini file contains an entry for Sybase, as in the following example:

   [Adaptive Server Enterprise]    
   Description=Sybase ODBC Driver
   Driver=/opt/sap/DataAccess64/ODBC/lib/libsybdrvodb.so    
   Setup=    
   FileUsage=-1    
   CPTimeout=    
   CPReuse=		

4. Start the Replicate service and optionally confirm that it has started as described in Replicate server procedures.